In this video we are going to discuss the options available in this fight.
Deb the filing time is mostly used for three purposes.
Opening a new workbook or an existing previously saved notebook second to save a book or thirdly to
print any part of the workbook
will discuss all of these and many of the features available in this filing written in this video.
Let's start when you click file the first option we see is new when you are working on excel and you
want to create a new empty workbook.
You have to go to file and select this new option.
This will display a screen that you can do the Blackwood book auto redesign template jus blank workbook
to open a new empty workbook.
The second option and file is open.
This is used to open previously saved files on the left.
You have to select the location from where you want to open the fight.
You can also click the bro's button to display the open dialog box by the way clicking any option will
open the open dialog box.
Now you have to look at your same file and double click on it.
Excellent.
Open your workbook SO LET'S OPEN THE LAST excel template which was on desktop the name was Excel basic.
Let's open it the next options in the file that are saving options.
Saving is very important function because workbooks are vulnerable to events such as powerful lawyers
and system crashes in such a event.
Any unsafe book is lost and you may have to redo all your work again.
So it is best practice to see a good book.
Often to save a workbook a workbook needs a file location and a file name.
So the first time we see what workbook we have to provide the location and the file name to complete
deceit.
The save can be initiated by doing any of the following either go to fight and select the save button
or select DC as button or you can go back and select this floppy disk icon button.
There is also a keyboard shortcut for this.
You can press control.
Plus the s alphabet keep to ensure DC yes when you're saving the file for the first time all four of
these methods do the same thing but once a file is saved save and save as behave a bit differently once
a file is saved Save button safety changes to the same fight again and again every time.
But if you click save as a new file will be saved which means Excel will again prompt you to give location
and name to save this workbook and the workbook will be saved with a new name at the new location
so here I'm saving the same file with the name Excel basic copy.
The location is the same which is desktop.
You can see that the active workbook now has the name Excel basic underscore copy.
This is the file that we see just now if you will give the same name and same location to the new file.
It will override the previous file with the new file.
Next we are going to cover passport protection yes you can apply a passport on your workbooks so that
nobody other than you can access your workbook whenever a user opens a password protected workbook a
password must be entered before the file is opened to say password.
Follow these tips go to fight in the info tab only you have to click on deep predict what button
in the problem.
There are many additional options we will not bother with many of them for now.
Just choose encrypt with password enter the password you want this okay.
Read into the password.
Will gagging and save the world.
Look no no whenever anyone reopens this book they will be prompted for a password.
Now lastly we are going to cover the printing options.
Many worksheets that you will develop with Excel will eventually end up as a hardcopy report.
You will find that printing from Excel is quite easy and that you can generate attractive very formatted
reports with minimum effort.
Let's see how we print an exit.
If you just want to print a copy of your worksheet with no fuss and bother.
Just click the file button then go to the printer.
And then hit the print button.
This is quick.
Printing an Excel will print your vote sheet.
The default settings you can select different printers from the dropdown here.
But in my experience the default printed page is not what we intend to print so it is important that
we can customize the content which will be printed on the page.
To see what will be printed before printing we usually print preview option Excel Shorty first page
exactly as it will be printed on the right to see other pages you'll debate controls along the bottom
of deep in print preview is suddenly useful but you may prefer the page layout view instead.
Let's see what that is.
In a workbook there are three new options.
Normal page layout and Page Brig view.
Normal is the default view page layout shows individual pages and page break view allows us to adjust
each page breaks
let's first change of you page layout and discuss this view you can see that these worksheets are divided
into pages and now you can visualize your printed output while you work on your worksheet.
This is why some people prefer page layout.
In place of print preview because print preview does not allow you to make changes to your worksheet
whereas here you can make changes as well in the third view which is paid break you.
You can adjust the page break borders also but other than that page load is the better view in showing
how your actual printed page will look.
We will not be discussing the third view for all that's all in this video.
Let me summarize quickly what all we learned in this we do we primarily discussed all the options that
we see in the Britain.
We first saw how to open a new Excel sheet.
We saw how to open previously see excel sheet using the open that.
We didn't know how to save our book using the save and save as buttons.
We then learned how to password protect our workbook using the protect workbook button.
And lastly we saw the printing options and how to preview the page before it is even printed.
So that's all in this video.
See you in the next one.